package com.dimension.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderidIsNull() {
            addCriterion("orderId is null");
            return (Criteria) this;
        }

        public Criteria andOrderidIsNotNull() {
            addCriterion("orderId is not null");
            return (Criteria) this;
        }

        public Criteria andOrderidEqualTo(Integer value) {
            addCriterion("orderId =", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotEqualTo(Integer value) {
            addCriterion("orderId <>", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThan(Integer value) {
            addCriterion("orderId >", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderId >=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThan(Integer value) {
            addCriterion("orderId <", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidLessThanOrEqualTo(Integer value) {
            addCriterion("orderId <=", value, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidIn(List<Integer> values) {
            addCriterion("orderId in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotIn(List<Integer> values) {
            addCriterion("orderId not in", values, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidBetween(Integer value1, Integer value2) {
            addCriterion("orderId between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrderidNotBetween(Integer value1, Integer value2) {
            addCriterion("orderId not between", value1, value2, "orderid");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNull() {
            addCriterion("orderNumber is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIsNotNull() {
            addCriterion("orderNumber is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumberEqualTo(Integer value) {
            addCriterion("orderNumber =", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotEqualTo(Integer value) {
            addCriterion("orderNumber <>", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThan(Integer value) {
            addCriterion("orderNumber >", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderNumber >=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThan(Integer value) {
            addCriterion("orderNumber <", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberLessThanOrEqualTo(Integer value) {
            addCriterion("orderNumber <=", value, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberIn(List<Integer> values) {
            addCriterion("orderNumber in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotIn(List<Integer> values) {
            addCriterion("orderNumber not in", values, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberBetween(Integer value1, Integer value2) {
            addCriterion("orderNumber between", value1, value2, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andOrdernumberNotBetween(Integer value1, Integer value2) {
            addCriterion("orderNumber not between", value1, value2, "ordernumber");
            return (Criteria) this;
        }

        public Criteria andGoodsidIsNull() {
            addCriterion("goodsId is null");
            return (Criteria) this;
        }

        public Criteria andGoodsidIsNotNull() {
            addCriterion("goodsId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsidEqualTo(Integer value) {
            addCriterion("goodsId =", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidNotEqualTo(Integer value) {
            addCriterion("goodsId <>", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidGreaterThan(Integer value) {
            addCriterion("goodsId >", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodsId >=", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidLessThan(Integer value) {
            addCriterion("goodsId <", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidLessThanOrEqualTo(Integer value) {
            addCriterion("goodsId <=", value, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidIn(List<Integer> values) {
            addCriterion("goodsId in", values, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidNotIn(List<Integer> values) {
            addCriterion("goodsId not in", values, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidBetween(Integer value1, Integer value2) {
            addCriterion("goodsId between", value1, value2, "goodsid");
            return (Criteria) this;
        }

        public Criteria andGoodsidNotBetween(Integer value1, Integer value2) {
            addCriterion("goodsId not between", value1, value2, "goodsid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userId is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userId is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("userId =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("userId <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("userId >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("userId >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("userId <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("userId <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("userId in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("userId not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("userId between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("userId not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNull() {
            addCriterion("orderNum is null");
            return (Criteria) this;
        }

        public Criteria andOrdernumIsNotNull() {
            addCriterion("orderNum is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernumEqualTo(Integer value) {
            addCriterion("orderNum =", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotEqualTo(Integer value) {
            addCriterion("orderNum <>", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThan(Integer value) {
            addCriterion("orderNum >", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumGreaterThanOrEqualTo(Integer value) {
            addCriterion("orderNum >=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThan(Integer value) {
            addCriterion("orderNum <", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumLessThanOrEqualTo(Integer value) {
            addCriterion("orderNum <=", value, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumIn(List<Integer> values) {
            addCriterion("orderNum in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotIn(List<Integer> values) {
            addCriterion("orderNum not in", values, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumBetween(Integer value1, Integer value2) {
            addCriterion("orderNum between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrdernumNotBetween(Integer value1, Integer value2) {
            addCriterion("orderNum not between", value1, value2, "ordernum");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIsNull() {
            addCriterion("orderPrice is null");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIsNotNull() {
            addCriterion("orderPrice is not null");
            return (Criteria) this;
        }

        public Criteria andOrderpriceEqualTo(BigDecimal value) {
            addCriterion("orderPrice =", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotEqualTo(BigDecimal value) {
            addCriterion("orderPrice <>", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceGreaterThan(BigDecimal value) {
            addCriterion("orderPrice >", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("orderPrice >=", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceLessThan(BigDecimal value) {
            addCriterion("orderPrice <", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("orderPrice <=", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIn(List<BigDecimal> values) {
            addCriterion("orderPrice in", values, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotIn(List<BigDecimal> values) {
            addCriterion("orderPrice not in", values, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orderPrice between", value1, value2, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orderPrice not between", value1, value2, "orderprice");
            return (Criteria) this;
        }

        public Criteria andIfpayIsNull() {
            addCriterion("ifPay is null");
            return (Criteria) this;
        }

        public Criteria andIfpayIsNotNull() {
            addCriterion("ifPay is not null");
            return (Criteria) this;
        }

        public Criteria andIfpayEqualTo(Integer value) {
            addCriterion("ifPay =", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayNotEqualTo(Integer value) {
            addCriterion("ifPay <>", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayGreaterThan(Integer value) {
            addCriterion("ifPay >", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayGreaterThanOrEqualTo(Integer value) {
            addCriterion("ifPay >=", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayLessThan(Integer value) {
            addCriterion("ifPay <", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayLessThanOrEqualTo(Integer value) {
            addCriterion("ifPay <=", value, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayIn(List<Integer> values) {
            addCriterion("ifPay in", values, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayNotIn(List<Integer> values) {
            addCriterion("ifPay not in", values, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayBetween(Integer value1, Integer value2) {
            addCriterion("ifPay between", value1, value2, "ifpay");
            return (Criteria) this;
        }

        public Criteria andIfpayNotBetween(Integer value1, Integer value2) {
            addCriterion("ifPay not between", value1, value2, "ifpay");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNull() {
            addCriterion("payTime is null");
            return (Criteria) this;
        }

        public Criteria andPaytimeIsNotNull() {
            addCriterion("payTime is not null");
            return (Criteria) this;
        }

        public Criteria andPaytimeEqualTo(Date value) {
            addCriterion("payTime =", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotEqualTo(Date value) {
            addCriterion("payTime <>", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThan(Date value) {
            addCriterion("payTime >", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payTime >=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThan(Date value) {
            addCriterion("payTime <", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeLessThanOrEqualTo(Date value) {
            addCriterion("payTime <=", value, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeIn(List<Date> values) {
            addCriterion("payTime in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotIn(List<Date> values) {
            addCriterion("payTime not in", values, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeBetween(Date value1, Date value2) {
            addCriterion("payTime between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andPaytimeNotBetween(Date value1, Date value2) {
            addCriterion("payTime not between", value1, value2, "paytime");
            return (Criteria) this;
        }

        public Criteria andIsshipIsNull() {
            addCriterion("isShip is null");
            return (Criteria) this;
        }

        public Criteria andIsshipIsNotNull() {
            addCriterion("isShip is not null");
            return (Criteria) this;
        }

        public Criteria andIsshipEqualTo(Integer value) {
            addCriterion("isShip =", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipNotEqualTo(Integer value) {
            addCriterion("isShip <>", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipGreaterThan(Integer value) {
            addCriterion("isShip >", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipGreaterThanOrEqualTo(Integer value) {
            addCriterion("isShip >=", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipLessThan(Integer value) {
            addCriterion("isShip <", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipLessThanOrEqualTo(Integer value) {
            addCriterion("isShip <=", value, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipIn(List<Integer> values) {
            addCriterion("isShip in", values, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipNotIn(List<Integer> values) {
            addCriterion("isShip not in", values, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipBetween(Integer value1, Integer value2) {
            addCriterion("isShip between", value1, value2, "isship");
            return (Criteria) this;
        }

        public Criteria andIsshipNotBetween(Integer value1, Integer value2) {
            addCriterion("isShip not between", value1, value2, "isship");
            return (Criteria) this;
        }

        public Criteria andShiptimeIsNull() {
            addCriterion("shipTime is null");
            return (Criteria) this;
        }

        public Criteria andShiptimeIsNotNull() {
            addCriterion("shipTime is not null");
            return (Criteria) this;
        }

        public Criteria andShiptimeEqualTo(Date value) {
            addCriterion("shipTime =", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeNotEqualTo(Date value) {
            addCriterion("shipTime <>", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeGreaterThan(Date value) {
            addCriterion("shipTime >", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeGreaterThanOrEqualTo(Date value) {
            addCriterion("shipTime >=", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeLessThan(Date value) {
            addCriterion("shipTime <", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeLessThanOrEqualTo(Date value) {
            addCriterion("shipTime <=", value, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeIn(List<Date> values) {
            addCriterion("shipTime in", values, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeNotIn(List<Date> values) {
            addCriterion("shipTime not in", values, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeBetween(Date value1, Date value2) {
            addCriterion("shipTime between", value1, value2, "shiptime");
            return (Criteria) this;
        }

        public Criteria andShiptimeNotBetween(Date value1, Date value2) {
            addCriterion("shipTime not between", value1, value2, "shiptime");
            return (Criteria) this;
        }

        public Criteria andIsreceiptIsNull() {
            addCriterion("isReceipt is null");
            return (Criteria) this;
        }

        public Criteria andIsreceiptIsNotNull() {
            addCriterion("isReceipt is not null");
            return (Criteria) this;
        }

        public Criteria andIsreceiptEqualTo(Integer value) {
            addCriterion("isReceipt =", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptNotEqualTo(Integer value) {
            addCriterion("isReceipt <>", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptGreaterThan(Integer value) {
            addCriterion("isReceipt >", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptGreaterThanOrEqualTo(Integer value) {
            addCriterion("isReceipt >=", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptLessThan(Integer value) {
            addCriterion("isReceipt <", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptLessThanOrEqualTo(Integer value) {
            addCriterion("isReceipt <=", value, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptIn(List<Integer> values) {
            addCriterion("isReceipt in", values, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptNotIn(List<Integer> values) {
            addCriterion("isReceipt not in", values, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptBetween(Integer value1, Integer value2) {
            addCriterion("isReceipt between", value1, value2, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andIsreceiptNotBetween(Integer value1, Integer value2) {
            addCriterion("isReceipt not between", value1, value2, "isreceipt");
            return (Criteria) this;
        }

        public Criteria andReceipttimeIsNull() {
            addCriterion("receiptTime is null");
            return (Criteria) this;
        }

        public Criteria andReceipttimeIsNotNull() {
            addCriterion("receiptTime is not null");
            return (Criteria) this;
        }

        public Criteria andReceipttimeEqualTo(Date value) {
            addCriterion("receiptTime =", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeNotEqualTo(Date value) {
            addCriterion("receiptTime <>", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeGreaterThan(Date value) {
            addCriterion("receiptTime >", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receiptTime >=", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeLessThan(Date value) {
            addCriterion("receiptTime <", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeLessThanOrEqualTo(Date value) {
            addCriterion("receiptTime <=", value, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeIn(List<Date> values) {
            addCriterion("receiptTime in", values, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeNotIn(List<Date> values) {
            addCriterion("receiptTime not in", values, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeBetween(Date value1, Date value2) {
            addCriterion("receiptTime between", value1, value2, "receipttime");
            return (Criteria) this;
        }

        public Criteria andReceipttimeNotBetween(Date value1, Date value2) {
            addCriterion("receiptTime not between", value1, value2, "receipttime");
            return (Criteria) this;
        }

        public Criteria andShipNumberIsNull() {
            addCriterion("ship_number is null");
            return (Criteria) this;
        }

        public Criteria andShipNumberIsNotNull() {
            addCriterion("ship_number is not null");
            return (Criteria) this;
        }

        public Criteria andShipNumberEqualTo(Integer value) {
            addCriterion("ship_number =", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberNotEqualTo(Integer value) {
            addCriterion("ship_number <>", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberGreaterThan(Integer value) {
            addCriterion("ship_number >", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("ship_number >=", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberLessThan(Integer value) {
            addCriterion("ship_number <", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberLessThanOrEqualTo(Integer value) {
            addCriterion("ship_number <=", value, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberIn(List<Integer> values) {
            addCriterion("ship_number in", values, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberNotIn(List<Integer> values) {
            addCriterion("ship_number not in", values, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberBetween(Integer value1, Integer value2) {
            addCriterion("ship_number between", value1, value2, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andShipNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("ship_number not between", value1, value2, "shipNumber");
            return (Criteria) this;
        }

        public Criteria andCreattimeIsNull() {
            addCriterion("creatTime is null");
            return (Criteria) this;
        }

        public Criteria andCreattimeIsNotNull() {
            addCriterion("creatTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreattimeEqualTo(Date value) {
            addCriterion("creatTime =", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotEqualTo(Date value) {
            addCriterion("creatTime <>", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeGreaterThan(Date value) {
            addCriterion("creatTime >", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeGreaterThanOrEqualTo(Date value) {
            addCriterion("creatTime >=", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeLessThan(Date value) {
            addCriterion("creatTime <", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeLessThanOrEqualTo(Date value) {
            addCriterion("creatTime <=", value, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeIn(List<Date> values) {
            addCriterion("creatTime in", values, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotIn(List<Date> values) {
            addCriterion("creatTime not in", values, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeBetween(Date value1, Date value2) {
            addCriterion("creatTime between", value1, value2, "creattime");
            return (Criteria) this;
        }

        public Criteria andCreattimeNotBetween(Date value1, Date value2) {
            addCriterion("creatTime not between", value1, value2, "creattime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}